package com.jdz.dao;

import com.jdz.pojo.ProjectDetails;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface ProjectDetailsMapper {
    int deleteByPrimaryKey(Integer projectno);

    int insert(ProjectDetails record);

    int insertSelective(ProjectDetails record);

    ProjectDetails selectByPrimaryKey(Integer projectno);

    int updateByPrimaryKeySelective(ProjectDetails record);

    int updateByPrimaryKey(ProjectDetails record);

    int selectByProjectCount(String projectname);

    ProjectDetails selectByProject(String projectname);

    int selectByProjectRaceTypeCount(String projectType);

    List<ProjectDetails> selectByProjectRaceType(String projectType);
//
//    List<ProjectDetails> selectByProjectInstitution(String );
    List<ProjectDetails> selectByProjectnoList(List<Integer> projectDetailsnoList);

    List<ProjectDetails> selectByProjectListManage(@Param("int_name") int int_name,  @Param("projectType") String projectType, @Param("name") String name, @Param("startTimeDate") Date startTimeDate, @Param("stopTimeDate") Date stopTimeDate);

    List<ProjectDetails> selectByProjectListManageTimeSort(@Param("int_name") int int_name, @Param("examineStatus") Integer examineStatus, @Param("projectType") String projectType, @Param("name") String name, @Param("startTimeDate") Date startTimeDate, @Param("stopTimeDate") Date stopTimeDate);

    List<ProjectDetails> selectSearchIndex(String name);

    int deleteByProjectno(Integer projectno);

    List<ProjectDetails> selectByProjectAll();

}